package com.example.hellonotes;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class NotesDB extends SQLiteOpenHelper{

	public static final String TABLE_NAME = "notes" ;
	public static final String CONTENT = "content" ;
	public static final String PATH = "path";
	public static final String ID = "_id" ;
	public static final String TIME = "time" ;
	
	public NotesDB(Context context) {
		super(context, "notes" , null , 1);
	}

	@Override
	//创建数据库
	public void onCreate(SQLiteDatabase db) {
		db.execSQL("CREATE TABLE " + TABLE_NAME + "(" 
				+ ID + " INTEGER PRIMARY KEY AUTOINCREMENT," 
				+ CONTENT + " TEXT NOT NULL," 
				+ PATH + " TEXT ,"
				+ TIME + " TEXT NOT NULL )");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO 自动生成的方法存根
		
	}

}
